Below analysis answers many questions raised by citi bike community like Where do Citi Bikers ride? When do they ride? How far do they go? Which stations are most popular? Busiest bike?
Dataset: https://s3.amazonaws.com/tripdata/index.html
Technologies
import pandas as pd
import matplotlib
top_5_start_station = pd.read_csv("top5StartStation/part-r-00000", index_col="station_name", delim_whitespace=True, names =["station_name", "popularity"])
top_5_start_station
top_5_start_station_graph = top_5_start_station.plot(kind='bar')
top_5_start_station_graph
top_5_end_station = pd.read_csv("top5EndStation/part-r-00000", index_col="station_name", delim_whitespace=True, names =["station_name", "popularity"])
top_5_end_station
top_5_end_station_graph = top_5_end_station.plot(kind='bar', color='#0099ff')
top_5_end_station_graph
top_5_journey = pd.read_csv("top5Journey/part-r-00000", engine='python', index_col="journey", sep = "\"\s", names =["journey", "popularity"])
top_5_journey
top_5_journey_graph = top_5_journey.plot(kind='bar', color='#0099ff')
top_5_journey_graph
ride_dist_on_age = pd.read_csv("RideDistributionOnAge/part-r-00000", index_col="age", delim_whitespace=True , names =["age", "count"])
ride_dist_on_age.head()
# ride_dist_on_age.plot.pie(subplots=True, figsize=(30,30))
ride_dist_on_age.plot.barh(figsize=(25,25),color='#0099ff')
ride_dist_on_hour = pd.read_csv("RideDistributionOnDayTime/part-r-00000", index_col="hour", delim_whitespace=True , names =["hour", "count"])
ride_dist_on_hour.head()
ride_dist_on_hour.plot.barh(figsize=(25,25), color='#0099ff')
CompositeKeyWritablePart4{stationName='"5 Corners Library"', tripduration=3359} CompositeKeyWritablePart4{stationName='"5 Corners Library"', tripduration=3590} CompositeKeyWritablePart4{stationName='"5 Corners Library"', tripduration=4218} CompositeKeyWritablePart4{stationName='"5 Corners Library"', tripduration=4446} CompositeKeyWritablePart4{stationName='"5 Corners Library"', tripduration=7437} CompositeKeyWritablePart4{stationName='"5 Corners Library"', tripduration=7458} CompositeKeyWritablePart4{stationName='"5 Corners Library"', tripduration=8786} CompositeKeyWritablePart4{stationName='"5 Corners Library"', tripduration=15434} CompositeKeyWritablePart4{stationName='"5 Corners Library"', tripduration=15472} CompositeKeyWritablePart4{stationName='"5 Corners Library"', tripduration=15492} CompositeKeyWritablePart4{stationName='"5 Corners Library"', tripduration=15668} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=103} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=109} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=130} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=131} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=136} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=142} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=156} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=158} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=163} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=164} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=165} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=166} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=169} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=170} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=171} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=173} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=175} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=179} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=199} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=199} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=203} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=206} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=207} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=207} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=209} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=222} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=223} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=224} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=228} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=233} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=233} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=241} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=251} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=254} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=255} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=258} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=264} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=269} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=271} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=276} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=280} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=280} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=282} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=284} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=286} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=289} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=289} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=290} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=292} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=294} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=296} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=296} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=296} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=298} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=298} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=299} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=300} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=301} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=301} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=301} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=302} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=303} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=303} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=303} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=304} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=304} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=304} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=304} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=304} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=305} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=305} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=305} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=306} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=307} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=308} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=308} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=309} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=310} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=310} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=310} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=310} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=310} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=311} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=313} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=313} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=313} CompositeKeyWritablePart4{stationName='"Astor Place"', tripduration=314}
matplotlib.pyplot.pie(x=[3209.65,504.38], autopct='%1.0f%%', labels=["Customer","Subscriber"], radius = 2)
matplotlib.pyplot.pie(x=[3147.0121,541.8469,698.4854], autopct='%1.0f%%', labels=["unknown","male","female"], radius=2)
matplotlib.pyplot.pie(x=[14312, 156156], autopct='%1.0f%%', labels=["Customer","Subscriber"], radius = 2)